﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Database.Model;

namespace Database.Control.Endereco
{
    public class Estado
    {
        public static object BuscaEstado(int idPais)
        {
            Entities context = new Entities();

            var p = (
                from c in context.TB_ESTADO
                where c.PAIS_ID==idPais
                select new
                {
                    c.ESTADO_ID,
                    c.SIGLA
                }
                );

            return p.ToList();
        }
    }
}
